﻿CREATE PROCEDURE [dbo].[ASMS_SP_QueryStationListByStaff]
	@staffId uniqueidentifier
AS
select S.*
from ASMS_V_Station as S
	where S.Id in (Select SP.StationId from ASMS_StaffPosition as SP where SP.StaffId=@staffId group by SP.StationId)
RETURN 0
